package com.elderlyCare.mapper;

import com.elderlyCare.pojo.SensorDataDaily;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface dataMapper {
    @Select("select * from sensor_data_daily")
    public List<SensorDataDaily> getData();

    @Select("select temperature from sensor_data_daily")
    public List<String> getTemperature();

    @Select("select humidity from sensor_data_daily")
    public List<String> getHumidity();

    @Select("select illumination from sensor_data_daily")
    public List<String> getIllumination();

    @Select("select oxygen from sensor_data_daily")
    public List<String> getOxygen();

    @Select("select carbonDioxide from sensor_data_daily")
    public List<String> getCarbonDioxide();

    @Select("select ultraviolet from sensor_data_daily")
    public List<String> getUltraviolet();

    @Select("select noise from sensor_data_daily")
    public List<String> getNoise();

    @Select("select smoke from sensor_data_daily")
    public List<String> getSmoke();

    @Select("select acceleration from sensor_data_daily")
    public List<String> getAcceleration();

    @Select("select combustible from sensor_data_daily")
    public List<String> getCombustible();
}
